<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateSTeaScheduleInfo extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('s_tea_schedule_info', function (Blueprint $table) {
            $table->increments('id');

            $table->integer('teacher_id')->comment("老师id")->index();
            $table->date('date_time')->comment("日期")->index();

            $table->integer('time_0800')->comment("时间08:00")->default(-1);
            $table->integer('time_0830')->comment("时间08:30")->default(-1);
            $table->integer('time_0900')->comment("时间09:00")->default(-1);
            $table->integer('time_0930')->comment("时间09:30")->default(-1);
            $table->integer('time_1000')->comment("时间10:00")->default(-1);
            $table->integer('time_1030')->comment("时间10:30")->default(-1);
            $table->integer('time_1100')->comment("时间11:00")->default(-1);
            $table->integer('time_1130')->comment("时间11:30")->default(-1);
            $table->integer('time_1200')->comment("时间12:00")->default(-1);
            $table->integer('time_1230')->comment("时间12:30")->default(-1);
            $table->integer('time_1300')->comment("时间13:00")->default(-1);
            $table->integer('time_1330')->comment("时间13:30")->default(-1);
            $table->integer('time_1400')->comment("时间14:00")->default(-1);
            $table->integer('time_1430')->comment("时间14:30")->default(-1);
            $table->integer('time_1500')->comment("时间15:00")->default(-1);
            $table->integer('time_1530')->comment("时间15:30")->default(-1);
            $table->integer('time_1600')->comment("时间16:00")->default(-1);
            $table->integer('time_1630')->comment("时间16:30")->default(-1);
            $table->integer('time_1700')->comment("时间17:00")->default(-1);
            $table->integer('time_1730')->comment("时间17:30")->default(-1);
            $table->integer('time_1800')->comment("时间18:00")->default(-1);
            $table->integer('time_1830')->comment("时间18:30")->default(-1);
            $table->integer('time_1900')->comment("时间19:00")->default(-1);
            $table->integer('time_1930')->comment("时间19:30")->default(-1);
            $table->integer('time_2000')->comment("时间20:00")->default(-1);
            $table->integer('time_2030')->comment("时间20:30")->default(-1);
            $table->integer('time_2100')->comment("时间21:00")->default(-1);
            $table->integer('time_2130')->comment("时间21:30")->default(-1);
            $table->integer('time_2200')->comment("时间22:00")->default(-1);
            $table->integer('time_2230')->comment("时间22:30")->default(-1);
            $table->integer('time_2300')->comment("时间23:00")->default(-1);
            $table->integer('time_2330')->comment("时间23:30")->default(-1);

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
